Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
BusinessUnitID (FK)(PK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_BSN_UN | Identity | integer | Tank(LO_TNK) |
TankID (FK)(PK) | A unique identifier for this Tank | ID_TNK | Identity | integer | Tank(LO_TNK) |
TankProbeID (PK) | A system assigned unique identifier for the TankProbe | ID_PBE_TNK | Identity | integer | |
EquipmentID (FK) | The fixed asset number assigned by the retailer for this particular piece of equipment. | ID_EQ | Identity | integer | Equipment(AS_EQ) |
UnitOfMeasureCode (FK) | The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355. | CD_UOM | Code | varchar(20) | UnitOfMeasure(CO_UOM) |
TypeCode | A manufacturer specific ID that specifies the type of probe that is installed. | TY_TNK_PBE | Code4 | char(4) | |
TankTiltOffset | The height offset that should be added to the measured fuel and water heights to account for the fact that the TankProbe is not installed in the centre of the Tank. | QL_OFST_TNK | Quantity | DECIMAL(9,3) | |